use SMS
drop procedure SMS_GetProduct
go
create procedure SMS_GetProduct
	@productId int
as
	select categoryId, productName, barcode, description, price
	from Products
	where productId=@productId or @productId is null